Excel 2024: Create Your First Pivot Table
May 2, 2024 - by Bill Jelen
Pivot tables let you summarize tabular data to a one-page summary in a few clicks. Start with a data set that has headings in row 1. It should have no blank rows, blank columns, blank headings or merged cells.
Select a single cell in your data and choose Insert, Pivot Table.
Excel will detect the edges of your data and offer to create the pivot table on a new worksheet. Click OK to accept the defaults.
Excel inserts a new blank worksheet to the left of the current worksheet. On the right side of the screen is the Pivot Table Fields pane. At the top, a list of your fields with checkboxes.